ADVANCED SHORT STATS For Koobi 5.4 Pro 
Written by Nulled.
[http://www.cathedral.net.ua]

  :
------------------------------------------

1)  /templates/***templates_name***/other
 stats.tpl  .

2)   /inc/functions.php 
  shortstats()     :




// ========================================================
// ADVANCED SHORT STATS For Koobi 5.4 Pro 
// Written by Nulled.
// [http://www.cathedral.net.ua]
// ========================================================
function shortstats()
{
    global $db,$THEME, $lang, $area;
    $tmpl = new Koobi("templates/");
    $gestern = mktime(0, 0, 0, date("m"), date("d")-1, date("Y"));
    $sql = $db->Query("SELECT SUM(visits) as VISITSALL FROM " . PREFIX . "_sitestats");$row = $sql->fetchrow();
    $sql = $db->Query("SELECT SUM(visits) as VISITSTODAY FROM " . PREFIX . "_sitestats WHERE datum='" . date("d-m-Y") . "'");$row2 = $sql->fetchrow();
    $sql = $db->Query("SELECT SUM(visits) as VISITSMONTH  FROM " . PREFIX . "_sitestats WHERE monat='" . date("m") . "'  AND jahr='" . date("Y") . "'");$row3 = $sql->fetchrow();
    $sql = $db->Query("SELECT MAX(visits) as VISITSMAX FROM " . PREFIX . "_sitestats");$row4 = $sql->fetchrow();
    $sql = $db->Query("SELECT SUM(visits) as VISITSGESTERN FROM " . PREFIX . "_sitestats WHERE tag='" . date("d", $gestern) . "' AND monat='" . date("m", $gestern) . "' AND jahr='" . date("Y", $gestern) . "'");$row5 = $sql->fetchrow();

// Query BEGIN -->>
	// HITS
		$sql = $db->Query("SELECT SUM(hits) as HITSTODAY FROM " . PREFIX . "_sitestats WHERE datum='" . date("d-m-Y") . "'");$row6 = $sql->fetchrow();
		$sql = $db->Query("SELECT SUM(hits) as HITSMONTH  FROM " . PREFIX . "_sitestats WHERE monat='" . date("m") . "'  AND jahr='" . date("Y") . "'");$row7 = $sql->fetchrow();
    		$sql = $db->Query("SELECT MAX(hits) as HITSMAX FROM " . PREFIX . "_sitestats");$row8 = $sql->fetchrow();
    		$sql = $db->Query("SELECT SUM(hits) as HITSGESTERN FROM " . PREFIX . "_sitestats WHERE tag='" . date("d", $gestern) . "' AND monat='" . date("m", $gestern) . "' AND jahr='" . date("Y", $gestern) . "'");$row9 = $sql->fetchrow();
		$sql = $db->Query("SELECT SUM(hits) as ALLHITS FROM " . PREFIX . "_sitestats");$row10 = $sql->fetchrow();
	// SITE STATS
		$sql_members = $db->Query("SELECT uid FROM " . PREFIX . "_user WHERE ugroup!=2 AND show_public=1 ");$num_members = $sql_members->numrows();
		$sql_posts = $db->Query("SELECT id FROM " . PREFIX . "_f_post");$num_posts = $sql_posts->numrows();
		$sql_threads = $db->Query("SELECT id FROM " . PREFIX . "_f_topic");$num_threads = $sql_threads->numrows();
		$sql_downloads = $db->Query("SELECT id FROM " . PREFIX . "_downloads WHERE active='1'");$num_downloads = $sql_downloads->numrows();
		$sql_manufacturer = $db->Query("SELECT id from " . PREFIX . "_manufacturer");$num_manufacturer = $sql_manufacturer->numrows();
		$sql_products = $db->Query("SELECT id FROM " . PREFIX . "_products");$num_products = $sql_products->numrows();
		$sql_news = $db->Query("SELECT newsid FROM " . PREFIX . "_news WHERE ispublic=1 ");$num_news = $sql_news->numrows();
		$sql_articles = $db->Query("SELECT id FROM " . PREFIX . "_articles WHERE active=1 ");$num_articles = $sql_articles->numrows();
		$sql_galleries  = $db->Query("SELECT id FROM " . PREFIX . "_gallery  WHERE active=1 ");$num_galleries  = $sql_galleries ->numrows();
		$sql_pictures  = $db->Query("SELECT id FROM " . PREFIX . "_gallery_items ");$num_pictures = $sql_pictures ->numrows();
		
	// COMENTS STATS
		$sql_newscomments = $db->Query("SELECT id FROM " . PREFIX . "_newscomments ");$num_comments_news = $sql_newscomments->numrows();
		$sql_articlecomments = $db->Query("SELECT id FROM " . PREFIX . "_articlecomments ");$num_comments_articles = $sql_articlecomments->numrows();
		$sql_gallerycomments = $db->Query("SELECT id FROM " . PREFIX . "_gallerycomments ");$num_comments_galleries = $sql_gallerycomments->numrows();
		$sql_pollcomments = $db->Query("SELECT id FROM " . PREFIX . "_pollcomments ");$num_comments_poll = $sql_pollcomments->numrows();
		$sql_downloadcomments = $db->Query("SELECT id FROM " . PREFIX . "_downloadcomments ");$num_comments_download = $sql_downloadcomments->numrows();


    $tmpl->assign('allvisits', $row->VISITSALL);
    $tmpl->assign('visitstoday', $row2->VISITSTODAY);
    $tmpl->assign('visitstmonth', $row3->VISITSMONTH);
    $tmpl->assign('visitsmax', $row4->VISITSMAX);
    $tmpl->assign('visityesterday', $row5->VISITSGESTERN);

// Template vars out BEGIN -->>
	// HITS
		$tmpl->assign('hitstoday', $row6->HITSTODAY);
		$tmpl->assign('hitstmonth', $row7->HITSMONTH);
    		$tmpl->assign('hitsmax', $row8->HITSMAX);
    		$tmpl->assign('hitsyesterday', $row9->HITSGESTERN);     
    		$tmpl->assign('allhits', $row10->ALLHITS);
	// SITE STATS
		$tmpl->assign('num_members', $num_members);
		$tmpl->assign('num_posts', $num_posts);
    		$tmpl->assign('num_threads', $num_threads);
    		$tmpl->assign('num_downloads', $num_downloads);
    		$tmpl->assign('num_manufacturer', $num_manufacturer);
    		$tmpl->assign('num_products', $num_products);
    		$tmpl->assign('num_news', $num_news);
		$tmpl->assign('num_articles', $num_articles);
		$tmpl->assign('num_galleries', $num_galleries);
		$tmpl->assign('num_pictures', $num_pictures);
	// COMENTS STATS
		$tmpl->assign('num_comments_news', $num_comments_news);
		$tmpl->assign('num_comments_articles', $num_comments_articles);
		$tmpl->assign('num_comments_galleries', $num_comments_galleries);
		$tmpl->assign('num_comments_poll', $num_comments_poll);
		$tmpl->assign('num_comments_download', $num_comments_download);


    $tmpl->assign('lang', $lang);
    $tmpl->assign('area', $area);
    echo $tmpl->fetch("$THEME/other/stats.tpl");
} 




    .
      ""   "+"
       "-". 
:))


Enjoy!